package com.data4.feignapi.common.constants;

public abstract class ProductConstants {
    public static final String QUERY_GROUP = "CAST(AVG(market_price) AS DECIMAL(10,2)) as avg_market_price," +
            "                        CAST(AVG(selling_price) AS DECIMAL(10,2)) as avg_selling_price," +
            "                        MIN(market_price) as min_market_price," +
            "                        MAX(market_price) as max_market_price," +
            "                        MIN(selling_price) as min_selling_price," +
            "                        MAX(selling_price) as max_selling_price,"+
            "                        COUNT(*) as product_count";
}
